from invenio.dbquery import run_sql

sql_string = "DROP TABLE IF EXISTS rnkMETHODdRank"
run_sql(sql_string)
sql_string = "CREATE TABLE IF NOT EXISTS rnkMETHODdRank (id_rnkMETHOD mediumint(9) unsigned NOT NULL, relevance_data longblob, data_last_updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00',raw_LUT longblob, appro_LUT longblob, LUT_last_updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  PRIMARY KEY (id_rnkMETHOD))"
run_sql(sql_string)

